'use strict';
/**
 * 创建 章节迁移文件
 * @type {import('sequelize-cli').Migration}
 * */
module.exports = {
	async up(queryInterface, Sequelize) {
		await queryInterface.createTable('Chapters', {
			id: {
				allowNull: false,
				autoIncrement: true,
				primaryKey: true,
				type: Sequelize.INTEGER.UNSIGNED
			},
			title: {
				allowNull: false,
				type: Sequelize.STRING
			},
			content: {
				type: Sequelize.TEXT
			},
			video: {
				type: Sequelize.STRING
			},
			rank: {
				type: Sequelize.INTEGER.UNSIGNED
			},
			courseId: {
				allowNull: false,
				type: Sequelize.INTEGER.UNSIGNED
			},
			createdAt: {
				allowNull: false,
				type: Sequelize.DATE
			},
			updatedAt: {
				allowNull: false,
				type: Sequelize.DATE
			}
		});
	},
	async down(queryInterface, Sequelize) {
		await queryInterface.addIndex('Chapters', {
			fields: ['courseId']
		});
	}
};